Pandas Profiling Report

Dataset statistics

Number of variables	42
Number of observations	20.000
Missing cells	32.430
Missing cells (%)	3.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	6.4 MiB
Average record size in memory	336.0 B

Variable types

NUM	17
CAT	13
BOOL	12

Warnings

`grau_instrucao` has constant value "20000"	Constant
`possui_telefone_celular` has constant value "20000"	Constant
`codigo_area_telefone_residencial` has a high cardinality: 81 distinct values	High cardinality
`codigo_area_telefone_trabalho` has a high cardinality: 77 distinct values	High cardinality
`qtde_contas_bancarias_especiais` is highly correlated with `qtde_contas_bancarias`	High correlation
`qtde_contas_bancarias` is highly correlated with `qtde_contas_bancarias_especiais`	High correlation
`local_onde_trabalha` is highly correlated with `local_onde_reside`	High correlation
`local_onde_reside` is highly correlated with `local_onde_trabalha`	High correlation
`qtde_contas_bancarias_especiais` is highly correlated with `qtde_contas_bancarias`	High correlation
`qtde_contas_bancarias` is highly correlated with `qtde_contas_bancarias_especiais`	High correlation
`tipo_residencia` has 536 (2.7%) missing values	Missing
`meses_na_residencia` has 1450 (7.3%) missing values	Missing
`profissao` has 3095 (15.5%) missing values	Missing
`ocupacao` has 2978 (14.9%) missing values	Missing
`profissao_companheiro` has 11511 (57.6%) missing values	Missing
`grau_instrucao_companheiro` has 12860 (64.3%) missing values	Missing
`renda_mensal_regular` is highly skewed (γ1 = 67.75421325)	Skewed
`renda_extra` is highly skewed (γ1 = 137.4095781)	Skewed
`valor_patrimonio_pessoal` is highly skewed (γ1 = 126.6995194)	Skewed
`meses_no_trabalho` is highly skewed (γ1 = 63.19895877)	Skewed
`id_solicitante` has unique values	Unique
`qtde_dependentes` has 13350 (66.8%) zeros	Zeros
`tipo_residencia` has 331 (1.7%) zeros	Zeros
`meses_na_residencia` has 1858 (9.3%) zeros	Zeros
`renda_extra` has 18930 (94.7%) zeros	Zeros
`valor_patrimonio_pessoal` has 19072 (95.4%) zeros	Zeros
`meses_no_trabalho` has 19973 (99.9%) zeros	Zeros
`profissao` has 1398 (7.0%) zeros	Zeros
`ocupacao` has 1114 (5.6%) zeros	Zeros
`profissao_companheiro` has 5551 (27.8%) zeros	Zeros
`grau_instrucao_companheiro` has 6485 (32.4%) zeros	Zeros

Reproduction

Analysis started	2021-05-24 18:17:51.613677
Analysis finished	2021-05-24 18:18:51.566884
Duration	59.95 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

id_solicitante
Real number (ℝ_≥0)

UNIQUE

Distinct	20000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10000.5
Minimum	1
Maximum	20000
Zeros	0
Zeros (%)	0.0%
Memory size	156.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1000.95
Q1	5000.75
median	10000.5
Q3	15000.25
95-th percentile	19000.05
Maximum	20000
Range	19999
Interquartile range (IQR)	9999.5

Descriptive statistics

Standard deviation	5773.647028
Coefficient of variation (CV)	0.577335836
Kurtosis	-1.2
Mean	10000.5
Median Absolute Deviation (MAD)	5000
Skewness	0
Sum	200010000
Variance	33335000
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2047	1	< 0.1%
10912	1	< 0.1%
12947	1	< 0.1%
2708	1	< 0.1%
661	1	< 0.1%
6806	1	< 0.1%
4759	1	< 0.1%
19100	1	< 0.1%
17053	1	< 0.1%
8865	1	< 0.1%
Other values (19990)	19990	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
20000	1	< 0.1%
19999	1	< 0.1%
19998	1	< 0.1%
19997	1	< 0.1%
19996	1	< 0.1%

produto_solicitado
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

1	17023
2	2435
7	542

Frequencies
Length

Value	Count	Frequency (%)
1	17023	85.1%
2	2435	12.2%
7	542	2.7%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

dia_vencimento
Real number (ℝ_≥0)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	13.14725
Minimum	1
Maximum	25
Zeros	0
Zeros (%)	0.0%
Memory size	156.2 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	10
median	10
Q3	20
95-th percentile	25
Maximum	25
Range	24
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	6.748506839
Coefficient of variation (CV)	0.5133017809
Kurtosis	-0.7233846608
Mean	13.14725
Median Absolute Deviation (MAD)	5
Skewness	0.441538168
Sum	262945
Variance	45.54234455
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
10	7847	39.2%
15	3557	17.8%
25	3089	15.4%
5	2825	14.1%
20	1952	9.8%
1	730	3.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	730	3.6%
5	2825	14.1%
10	7847	39.2%
15	3557	17.8%
20	1952	9.8%

Value	Count	Frequency (%)
25	3089	15.4%
20	1952	9.8%
15	3557	17.8%
10	7847	39.2%
5	2825	14.1%

forma_envio_solicitacao
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

internet	11264
presencial	7855
correio	881

Frequencies
Length

Value	Count	Frequency (%)
internet	11264	56.3%
presencial	7855	39.3%
correio	881	4.4%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	10
Median length	8
Mean length	8.74145
Min length	7

tipo_endereco
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

1	19873
2	127

Frequencies
Length

Value	Count	Frequency (%)
1	19873	99.4%
2	127	0.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

sexo
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

F	12246
M	7722
N	25
	7

Frequencies
Length

Value	Count	Frequency (%)
F	12246	61.2%
M	7722	38.6%
N	25	0.1%
	7	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

idade
Real number (ℝ_≥0)

Distinct	84
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	42.3525
Minimum	7
Maximum	106
Zeros	0
Zeros (%)	0.0%
Memory size	156.2 KiB

Quantile statistics

Minimum	7
5-th percentile	21
Q1	31
median	40
Q3	52
95-th percentile	70
Maximum	106
Range	99
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	14.93017713
Coefficient of variation (CV)	0.3525217433
Kurtosis	-0.210705359
Mean	42.3525
Median Absolute Deviation (MAD)	10
Skewness	0.5584304521
Sum	847050
Variance	222.9101893
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40	555	2.8%
39	534	2.7%
36	526	2.6%
32	518	2.6%
37	513	2.6%
43	510	2.5%
28	509	2.5%
33	504	2.5%
31	503	2.5%
38	500	2.5%
Other values (74)	14828	74.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7	1	< 0.1%
17	7	< 0.1%
18	265	1.3%
19	260	1.3%
20	293	1.5%

Value	Count	Frequency (%)
106	2	< 0.1%
100	1	< 0.1%
97	1	< 0.1%
96	2	< 0.1%
95	4	< 0.1%

estado_civil
Real number (ℝ_≥0)

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.12085
Minimum	0
Maximum	7
Zeros	81
Zeros (%)	0.4%
Memory size	156.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	5
Maximum	7
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.33200375
Coefficient of variation (CV)	0.6280518423
Kurtosis	2.799170933
Mean	2.12085
Median Absolute Deviation (MAD)	0
Skewness	1.76004596
Sum	42417
Variance	1.774233989
Monotocity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2	10088	50.4%
1	6519	32.6%
4	1573	7.9%
6	763	3.8%
5	522	2.6%
3	234	1.2%
7	220	1.1%
0	81	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	81	0.4%
1	6519	32.6%
2	10088	50.4%
3	234	1.2%
4	1573	7.9%

Value	Count	Frequency (%)
7	220	1.1%
6	763	3.8%
5	522	2.6%
4	1573	7.9%
3	234	1.2%

qtde_dependentes
Real number (ℝ_≥0)

ZEROS

Distinct	15
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.6664
Minimum	0
Maximum	53
Zeros	13350
Zeros (%)	66.8%
Memory size	156.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	53
Range	53
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.23672451
Coefficient of variation (CV)	1.855829097
Kurtosis	167.6045062
Mean	0.6664
Median Absolute Deviation (MAD)	0
Skewness	5.925042325
Sum	13328
Variance	1.529487514
Monotocity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
0	13350	66.8%
1	2814	14.1%
2	2189	10.9%
3	1029	5.1%
4	352	1.8%
5	149	0.7%
6	57	0.3%
7	22	0.1%
8	14	0.1%
9	9	< 0.1%
Other values (5)	15	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	13350	66.8%
1	2814	14.1%
2	2189	10.9%
3	1029	5.1%
4	352	1.8%

Value	Count	Frequency (%)
53	1	< 0.1%
14	1	< 0.1%
13	2	< 0.1%
11	4	< 0.1%
10	7	< 0.1%

grau_instrucao
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

0	20000

Common Values
Chart

Value	Count	Frequency (%)
0	20000	100.0%

nacionalidade
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

1	19152
0	808
2	40

Frequencies
Length

Value	Count	Frequency (%)
1	19152	95.8%
0	808	4.0%
2	40	0.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

estado_onde_nasceu
Categorical

Distinct	28
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

BA	2351
SP	2336
RS	1919
CE	1910
PE	1651
Other values (23)	9833

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
BA	2351	11.8%
SP	2336	11.7%
RS	1919	9.6%
CE	1910	9.6%
PE	1651	8.3%
MG	1446	7.2%
RN	827	4.1%
	822	4.1%
PR	764	3.8%
RJ	720	3.6%
Other values (18)	5254	26.3%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	2
Median length	2
Mean length	1.9589
Min length	1

estado_onde_reside
Categorical

Distinct	27
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

SP	3578
BA	2045
RS	1995
CE	1865
PE	1484
Other values (22)	9033

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
SP	3578	17.9%
BA	2045	10.2%
RS	1995	10.0%
CE	1865	9.3%
PE	1484	7.4%
MG	1187	5.9%
PA	927	4.6%
RJ	863	4.3%
RN	846	4.2%
GO	682	3.4%
Other values (17)	4528	22.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	2
Median length	2
Mean length	2
Min length	2

possui_telefone_residencial
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Y	16474
N	3526

Common Values
Chart

Value	Count	Frequency (%)
Y	16474	82.4%
N	3526	17.6%

codigo_area_telefone_residencial
Categorical

HIGH CARDINALITY

Distinct	81
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

	3534
5	1838
107	1142
97	1142
54	904
Other values (76)	11440

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
	3534	17.7%
5	1838	9.2%
107	1142	5.7%
97	1142	5.7%
54	904	4.5%
105	646	3.2%
84	545	2.7%
81	535	2.7%
20	534	2.7%
58	518	2.6%
Other values (71)	8662	43.3%

Frequencies of value counts

Unique

Unique	11 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	2
Mean length	1.9452
Min length	1

tipo_residencia
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	536
Missing (%)	2.7%
Infinite	0
Infinite (%)	0.0%

Mean	1.261302918
Minimum	0
Maximum	5
Zeros	331
Zeros (%)	1.7%
Memory size	156.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	3
Maximum	5
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.8835795418
Coefficient of variation (CV)	0.7005292139
Kurtosis	11.37714604
Mean	1.261302918
Median Absolute Deviation (MAD)	0
Skewness	3.408604224
Sum	24550
Variance	0.7807128068
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	16497	82.5%
2	1635	8.2%
5	827	4.1%
0	331	1.7%
4	126	0.6%
3	48	0.2%
(Missing)	536	2.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	331	1.7%
1	16497	82.5%
2	1635	8.2%
3	48	0.2%
4	126	0.6%

Value	Count	Frequency (%)
5	827	4.1%
4	126	0.6%
3	48	0.2%
2	1635	8.2%
1	16497	82.5%

meses_na_residencia
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	76
Distinct (%)	0.4%
Missing	1450
Missing (%)	7.3%
Infinite	0
Infinite (%)	0.0%

Mean	9.57245283
Minimum	0
Maximum	228
Zeros	1858
Zeros (%)	9.3%
Memory size	156.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	6
Q3	15
95-th percentile	30
Maximum	228
Range	228
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	10.64958027
Coefficient of variation (CV)	1.112523661
Kurtosis	18.11111445
Mean	9.57245283
Median Absolute Deviation (MAD)	5
Skewness	2.340849526
Sum	177569
Variance	113.4135599
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2937	14.7%
0	1858	9.3%
10	1510	7.5%
5	1486	7.4%
2	1319	6.6%
3	953	4.8%
20	934	4.7%
15	776	3.9%
8	672	3.4%
6	666	3.3%
Other values (66)	5439	27.2%
(Missing)	1450	7.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1858	9.3%
1	2937	14.7%
2	1319	6.6%
3	953	4.8%
4	643	3.2%

Value	Count	Frequency (%)
228	1	< 0.1%
200	1	< 0.1%
100	1	< 0.1%
96	1	< 0.1%
89	1	< 0.1%

possui_telefone_celular
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

N	20000

Frequencies
Length

Value	Count	Frequency (%)
N	20000	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

possui_email
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

1	15984
0	4016

Common Values
Chart

Value	Count	Frequency (%)
1	15984	79.9%
0	4016	20.1%

renda_mensal_regular
Real number (ℝ_≥0)

SKEWED

Distinct	3031
Distinct (%)	15.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	957.1309375
Minimum	69
Maximum	959000
Zeros	0
Zeros (%)	0.0%
Memory size	156.2 KiB

Quantile statistics

Minimum	69
5-th percentile	289
Q1	360
median	500
Q3	800
95-th percentile	1782.05
Maximum	959000
Range	958931
Interquartile range (IQR)	440

Descriptive statistics

Standard deviation	11353.965
Coefficient of variation (CV)	11.86249922
Kurtosis	5062.489381
Mean	957.1309375
Median Absolute Deviation (MAD)	150
Skewness	67.75421325
Sum	19142618.75
Variance	128912521.2
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
350	2808	14.0%
500	628	3.1%
400	579	2.9%
380	546	2.7%
600	513	2.6%
700	419	2.1%
800	388	1.9%
450	340	1.7%
300	337	1.7%
1000	248	1.2%
Other values (3021)	13194	66.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
69	1	< 0.1%
100	5	< 0.1%
105	1	< 0.1%
115	1	< 0.1%
120	5	< 0.1%

Value	Count	Frequency (%)
959000	1	< 0.1%
875000	1	< 0.1%
668000	1	< 0.1%
486778	1	< 0.1%
174274	1	< 0.1%

renda_extra
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	284
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	39.0969585
Minimum	0
Maximum	194344
Zeros	18930
Zeros (%)	94.7%
Memory size	156.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	100
Maximum	194344
Range	194344
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1387.42878
Coefficient of variation (CV)	35.48687247
Kurtosis	19237.66506
Mean	39.0969585
Median Absolute Deviation (MAD)	0
Skewness	137.4095781
Sum	781939.17
Variance	1924958.62
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	18930	94.7%
350	136	0.7%
600	61	0.3%
300	58	0.3%
400	57	0.3%
200	57	0.3%
500	53	0.3%
800	31	0.2%
250	29	0.1%
150	25	0.1%
Other values (274)	563	2.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	18930	94.7%
1	1	< 0.1%
3	1	< 0.1%
15	2	< 0.1%
31.48	1	< 0.1%

Value	Count	Frequency (%)
194344	1	< 0.1%
10200	1	< 0.1%
8341	1	< 0.1%
5400	1	< 0.1%
5000	1	< 0.1%

possui_cartao_visa
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

0	17822
1	2178

Common Values
Chart

Value	Count	Frequency (%)
0	17822	89.1%
1	2178	10.9%

possui_cartao_mastercard
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

0	18101
1	1899

Common Values
Chart

Value	Count	Frequency (%)
0	18101	90.5%
1	1899	9.5%

possui_cartao_diners
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

0	19968
1	32

Common Values
Chart

Value	Count	Frequency (%)
0	19968	99.8%
1	32	0.2%

possui_cartao_amex
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

0	19959
1	41

Common Values
Chart

Value	Count	Frequency (%)
0	19959	99.8%
1	41	0.2%

possui_outros_cartoes
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

0	19955
1	45

Common Values
Chart

Value	Count	Frequency (%)
0	19955	99.8%
1	45	0.2%

qtde_contas_bancarias
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

0	12786
1	7206
2	8

Frequencies
Length

Value	Count	Frequency (%)
0	12786	63.9%
1	7206	36.0%
2	8	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

qtde_contas_bancarias_especiais
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

0	12786
1	7206
2	8

Frequencies
Length

Value	Count	Frequency (%)
0	12786	63.9%
1	7206	36.0%
2	8	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

valor_patrimonio_pessoal
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	94
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2095.614
Minimum	0
Maximum	6000000
Zeros	19072
Zeros (%)	95.4%
Memory size	156.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	6000000
Range	6000000
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	44033.43658
Coefficient of variation (CV)	21.01218859
Kurtosis	17218.03756
Mean	2095.614
Median Absolute Deviation (MAD)	0
Skewness	126.6995194
Sum	41912280
Variance	1938943537
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19072	95.4%
25000	87	0.4%
30000	86	0.4%
20000	83	0.4%
50000	71	0.4%
15000	66	0.3%
35000	63	0.3%
40000	48	0.2%
45000	39	0.2%
60000	37	0.2%
Other values (84)	348	1.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	19072	95.4%
7	1	< 0.1%
15	1	< 0.1%
17	1	< 0.1%
18	2	< 0.1%

Value	Count	Frequency (%)
6000000	1	< 0.1%
600000	1	< 0.1%
450000	1	< 0.1%
320000	1	< 0.1%
250000	2	< 0.1%

possui_carro
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

0	13219
1	6781

Common Values
Chart

Value	Count	Frequency (%)
0	13219	66.1%
1	6781	33.9%

vinculo_formal_com_empresa
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

N	11174
Y	8826

Common Values
Chart

Value	Count	Frequency (%)
N	11174	55.9%
Y	8826	44.1%

estado_onde_trabalha
Categorical

Distinct	28
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

	13573
SP	1010
RS	819
CE	588
BA	569
Other values (23)	3441

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
	13573	67.9%
SP	1010	5.1%
RS	819	4.1%
CE	588	2.9%
BA	569	2.8%
MG	500	2.5%
PE	369	1.8%
PA	316	1.6%
PR	236	1.2%
RJ	229	1.1%
Other values (18)	1791	9.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	2
Median length	1
Mean length	1.32135
Min length	1

possui_telefone_trabalho
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

N	14519
Y	5481

Common Values
Chart

Value	Count	Frequency (%)
N	14519	72.6%
Y	5481	27.4%

codigo_area_telefone_trabalho
Categorical

HIGH CARDINALITY

Distinct	77
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

	14525
5	631
54	442
107	407
97	264
Other values (72)	3731

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
	14525	72.6%
5	631	3.2%
54	442	2.2%
107	407	2.0%
97	264	1.3%
81	196	1.0%
29	187	0.9%
66	184	0.9%
105	182	0.9%
58	178	0.9%
Other values (67)	2804	14.0%

Frequencies of value counts

Unique

Unique	9 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.30375
Min length	1

meses_no_trabalho
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.0089
Minimum	0
Maximum	32
Zeros	19973
Zeros (%)	99.9%
Memory size	156.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	32
Range	32
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3888808962
Coefficient of variation (CV)	43.69448272
Kurtosis	4536.037419
Mean	0.0089
Median Absolute Deviation (MAD)	0
Skewness	63.19895877
Sum	178
Variance	0.1512283514
Monotocity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
0	19973	99.9%
1	7	< 0.1%
3	4	< 0.1%
2	4	< 0.1%
6	2	< 0.1%
5	2	< 0.1%
4	2	< 0.1%
15	1	< 0.1%
30	1	< 0.1%
14	1	< 0.1%
Other values (3)	3	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	19973	99.9%
1	7	< 0.1%
2	4	< 0.1%
3	4	< 0.1%
4	2	< 0.1%

Value	Count	Frequency (%)
32	1	< 0.1%
30	1	< 0.1%
18	1	< 0.1%
15	1	< 0.1%
14	1	< 0.1%

profissao
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	19
Distinct (%)	0.1%
Missing	3095
Missing (%)	15.5%
Infinite	0
Infinite (%)	0.0%

Mean	8.045607808
Minimum	0
Maximum	18
Zeros	1398
Zeros (%)	7.0%
Memory size	156.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	9
median	9
Q3	9
95-th percentile	11
Maximum	18
Range	18
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.211523085
Coefficient of variation (CV)	0.3991647569
Kurtosis	1.647157368
Mean	8.045607808
Median Absolute Deviation (MAD)	0
Skewness	-1.482972287
Sum	136011
Variance	10.31388052
Monotocity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
9	12103	60.5%
0	1398	7.0%
11	1349	6.7%
2	1171	5.9%
12	192	1.0%
10	173	0.9%
16	126	0.6%
13	125	0.6%
7	90	0.4%
8	61	0.3%
Other values (9)	117	0.6%
(Missing)	3095	15.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1398	7.0%
1	1	< 0.1%
2	1171	5.9%
3	7	< 0.1%
4	13	0.1%

Value	Count	Frequency (%)
18	1	< 0.1%
17	16	0.1%
16	126	0.6%
15	25	0.1%
14	6	< 0.1%

ocupacao
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	2978
Missing (%)	14.9%
Infinite	0
Infinite (%)	0.0%

Mean	2.533309834
Minimum	0
Maximum	5
Zeros	1114
Zeros (%)	5.6%
Memory size	156.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	5
Maximum	5
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.532765217
Coefficient of variation (CV)	0.6050445137
Kurtosis	-1.064418569
Mean	2.533309834
Median Absolute Deviation (MAD)	1
Skewness	0.3443705658
Sum	43122
Variance	2.34936921
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2	6882	34.4%
1	3144	15.7%
4	2924	14.6%
5	2822	14.1%
0	1114	5.6%
3	136	0.7%
(Missing)	2978	14.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1114	5.6%
1	3144	15.7%
2	6882	34.4%
3	136	0.7%
4	2924	14.6%

Value	Count	Frequency (%)
5	2822	14.1%
4	2924	14.6%
3	136	0.7%
2	6882	34.4%
1	3144	15.7%

profissao_companheiro
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	17
Distinct (%)	0.2%
Missing	11511
Missing (%)	57.6%
Infinite	0
Infinite (%)	0.0%

Mean	3.711509012
Minimum	0
Maximum	18
Zeros	5551
Zeros (%)	27.8%
Memory size	156.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	11
95-th percentile	11
Maximum	18
Range	18
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	5.184218121
Coefficient of variation (CV)	1.39679524
Kurtosis	-1.352740291
Mean	3.711509012
Median Absolute Deviation (MAD)	0
Skewness	0.7297457824
Sum	31507
Variance	26.87611753
Monotocity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	5551	27.8%
11	2358	11.8%
9	409	2.0%
16	78	0.4%
2	39	0.2%
12	15	0.1%
10	13	0.1%
6	9	< 0.1%
13	5	< 0.1%
17	3	< 0.1%
Other values (7)	9	< 0.1%
(Missing)	11511	57.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5551	27.8%
1	1	< 0.1%
2	39	0.2%
3	1	< 0.1%
6	9	< 0.1%

Value	Count	Frequency (%)
18	1	< 0.1%
17	3	< 0.1%
16	78	0.4%
15	1	< 0.1%
14	1	< 0.1%

grau_instrucao_companheiro
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	6
Distinct (%)	0.1%
Missing	12860
Missing (%)	64.3%
Infinite	0
Infinite (%)	0.0%

Mean	0.2880952381
Minimum	0
Maximum	5
Zeros	6485
Zeros (%)	32.4%
Memory size	156.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	3
Maximum	5
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.9443388652
Coefficient of variation (CV)	3.277870441
Kurtosis	8.751956221
Mean	0.2880952381
Median Absolute Deviation (MAD)	0
Skewness	3.183826767
Sum	2057
Variance	0.8917758923
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	6485	32.4%
3	245	1.2%
4	244	1.2%
2	132	0.7%
1	22	0.1%
5	12	0.1%
(Missing)	12860	64.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6485	32.4%
1	22	0.1%
2	132	0.7%
3	245	1.2%
4	244	1.2%

Value	Count	Frequency (%)
5	12	0.1%
4	244	1.2%
3	245	1.2%
2	132	0.7%
1	22	0.1%

local_onde_reside
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	743
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	581.29525
Minimum	105
Maximum	999
Zeros	0
Zeros (%)	0.0%
Memory size	156.2 KiB

Quantile statistics

Minimum	105
5-th percentile	148
Q1	444
median	596
Q3	728
95-th percentile	956
Maximum	999
Range	894
Interquartile range (IQR)	284

Descriptive statistics

Standard deviation	227.369798
Coefficient of variation (CV)	0.3911433957
Kurtosis	-0.5758248011
Mean	581.29525
Median Absolute Deviation (MAD)	144
Skewness	-0.2500355883
Sum	11625905
Variance	51697.02503
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
960	367	1.8%
591	345	1.7%
570	310	1.6%
456	256	1.3%
628	249	1.2%
685	222	1.1%
596	205	1.0%
689	196	1.0%
619	194	1.0%
581	189	0.9%
Other values (733)	17467	87.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
105	1	< 0.1%
110	11	0.1%
112	1	< 0.1%
113	83	0.4%
114	46	0.2%

Value	Count	Frequency (%)
999	2	< 0.1%
998	1	< 0.1%
997	4	< 0.1%
996	2	< 0.1%
995	8	< 0.1%

local_onde_trabalha
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	743
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	581.29525
Minimum	105
Maximum	999
Zeros	0
Zeros (%)	0.0%
Memory size	156.2 KiB

Quantile statistics

Minimum	105
5-th percentile	148
Q1	444
median	596
Q3	728
95-th percentile	956
Maximum	999
Range	894
Interquartile range (IQR)	284

Descriptive statistics

Standard deviation	227.369798
Coefficient of variation (CV)	0.3911433957
Kurtosis	-0.5758248011
Mean	581.29525
Median Absolute Deviation (MAD)	144
Skewness	-0.2500355883
Sum	11625905
Variance	51697.02503
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
960	367	1.8%
591	345	1.7%
570	310	1.6%
456	256	1.3%
628	249	1.2%
685	222	1.1%
596	205	1.0%
689	196	1.0%
619	194	1.0%
581	189	0.9%
Other values (733)	17467	87.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
105	1	< 0.1%
110	11	0.1%
112	1	< 0.1%
113	83	0.4%
114	46	0.2%

Value	Count	Frequency (%)
999	2	< 0.1%
998	1	< 0.1%
997	4	< 0.1%
996	2	< 0.1%
995	8	< 0.1%

inadimplente
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

1	10000
0	10000

Common Values
Chart

Value	Count	Frequency (%)
1	10000	50.0%
0	10000	50.0%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	id_solicitante	produto_solicitado	dia_vencimento	forma_envio_solicitacao	tipo_endereco	sexo	idade	estado_civil	qtde_dependentes	nacionalidade	estado_onde_nasceu	estado_onde_reside	possui_telefone_residencial	codigo_area_telefone_residencial	tipo_residencia	meses_na_residencia	possui_telefone_celular	possui_email	renda_mensal_regular	renda_extra	possui_cartao_visa	qtde_contas_bancarias	qtde_contas_bancarias_especiais	possui_carro	vinculo_formal_com_empresa	estado_onde_trabalha	possui_telefone_trabalho	codigo_area_telefone_trabalho	profissao	ocupacao	profissao_companheiro	grau_instrucao_companheiro	local_onde_reside	local_onde_trabalha	inadimplente
0	1	1	10	presencial	1	M	85	2	0	1	CE	CE	Y	107	1.0	12.0	N	0	480.0	0.0	0	1	1	1	N		N		9.0	1.0	0.0	0.0	600	600	0
1	2	1	25	internet	1	F	38	1	0	1	SE	SE	Y	91	1.0	5.0	N	1	380.0	0.0	0	0	0	0	N		N		2.0	5.0	NaN	NaN	492	492	0
2	3	1	20	internet	1	F	37	2	0	1	BA	BA	Y	90	5.0	1.0	N	1	600.0	0.0	0	0	0	0	N		N		7.0	NaN	15.0	NaN	450	450	1
3	4	1	20	internet	1	M	37	1	1	1	RS	RS	Y	54	1.0	1.0	N	1	460.0	0.0	0	0	0	0	Y	RS	Y	54	9.0	2.0	18.0	NaN	932	932	1
4	5	7	1	internet	1	F	51	1	3	1	BA	BA	Y	86	0.0	1.0	N	1	687.0	600.0	0	0	0	1	Y	BA	N		9.0	5.0	NaN	NaN	440	440	1
5	6	1	20	presencial	1	M	21	1	1	1	CE	CE	Y	107	5.0	2.0	N	0	382.0	0.0	1	0	0	1	Y	CE	Y	107	9.0	2.0	0.0	0.0	628	628	1
6	7	1	15	presencial	1	F	64	4	2	1	SP	SP	Y	16	1.0	0.0	N	1	350.0	0.0	0	1	1	1	N		N		10.0	1.0	0.0	0.0	190	190	1
7	8	1	5	internet	1	F	20	1	0	1	ES	ES	Y	25	1.0	5.0	N	1	800.0	0.0	0	0	0	0	N		N		18.0	NaN	7.0	NaN	299	299	1
8	9	2	25	internet	1	F	39	2	2	1	GO	GO	Y	67	1.0	3.0	N	1	1200.0	0.0	1	0	0	0	Y		Y	69	9.0	2.0	9.0	4.0	756	756	0
9	10	1	10	presencial	1	M	44	2	2	1	RS	RS	N		1.0	15.0	N	0	749.0	0.0	0	1	1	1	Y	RS	N		9.0	2.0	16.0	4.0	960	960	1

Last rows

	id_solicitante	produto_solicitado	dia_vencimento	forma_envio_solicitacao	tipo_endereco	sexo	idade	estado_civil	qtde_dependentes	nacionalidade	estado_onde_nasceu	estado_onde_reside	possui_telefone_residencial	codigo_area_telefone_residencial	tipo_residencia	meses_na_residencia	possui_telefone_celular	possui_email	renda_mensal_regular	qtde_contas_bancarias	qtde_contas_bancarias_especiais	possui_carro	vinculo_formal_com_empresa	possui_telefone_trabalho	profissao	ocupacao	profissao_companheiro	grau_instrucao_companheiro	local_onde_reside	local_onde_trabalha	inadimplente
19990	19991	1	10	presencial	1	F	52	4	0	1	SP	PR	N		1.0	0.0	N	0	350.0	1	1	1	N	N	0.0	1.0	0.0	0.0	872	872	1
19991	19992	1	10	presencial	1	M	48	2	2	1	MG	MG	N		1.0	6.0	N	0	1308.0	1	1	1	N	N	0.0	1.0	0.0	0.0	351	351	1
19992	19993	1	5	internet	1	M	62	4	0	1	ES	RJ	Y	20	1.0	30.0	N	1	358.0	0	0	0	N	N	9.0	1.0	NaN	NaN	230	230	0
19993	19994	1	5	internet	1	F	18	1	0	1	RJ	RJ	Y	22	1.0	6.0	N	1	405.0	0	0	0	N	N	9.0	2.0	NaN	NaN	289	289	0
19994	19995	2	5	presencial	1	M	23	2	0	1	BA	BA	Y	84	1.0	23.0	N	0	350.0	1	1	1	N	N	0.0	0.0	0.0	0.0	457	457	1
19995	19996	1	10	presencial	1	M	27	2	0	1	MG	MG	Y	29	2.0	0.0	N	1	423.0	1	1	1	Y	N	9.0	1.0	0.0	0.0	308	308	0
19996	19997	1	20	presencial	1	F	26	2	1	1	CE	CE	Y	107	1.0	3.0	N	0	350.0	1	1	1	Y	N	9.0	2.0	0.0	0.0	639	639	0
19997	19998	1	10	internet	1	F	63	2	0	1	BA	BA	Y	86	5.0	25.0	N	1	321.0	0	0	0	N	N	9.0	1.0	NaN	NaN	486	486	0
19998	19999	1	5	internet	1	F	84	1	0	1	PB	RN	N		1.0	30.0	N	1	380.0	0	0	0	N	N	NaN	NaN	NaN	NaN	590	590	0
19999	20000	2	20	presencial	1	F	53	1	0	1	MA	SP	Y	5	1.0	11.0	N	1	300.0	1	1	1	N	N	9.0	5.0	0.0	0.0	132	132	0

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows